2015-05-27 - 19505 - Service Request - Update UPC Program (Dan by 2015-06-19) #ProductionBreakFix #SDSupportUPCLabels #ABAPUPC
2015-05-27 - 19505 - Service Request - Update UPC Program
Problem Summary
Update the UPC program, so that printing by PO can read from table- 912 (SOrg / Distr. Chl / Division / Customer / Plant / VAS Matl. Grp.).
Admin Info
| Purpose |
Update UPC program |
| Requested by |
Daniel Brennan |
| Issue Date |
05-27-2015 |
| Resolved by |
Surya/Siba/Karthik |
| Resolved Date |
08/18/2015 |
| Document Status |
Completed |
Detailed Problem Description
(Include Screen Shots if required )- Update the UPC program by adding new VAS table KOTK912- (SOrg / Distr. Chl / Division / Customer / Plant / VAS Matl. Grp.) So that while printing UPC labels by PO, can read this table.
- Valid VAS code should be printed.
- Avoid printing extra lines when same VAS codes exist in multiple records.
Solution Analysis and Recommendations
(Include Screen Shots if required)Below changes are required to update in UPC program.
- Add VAS condition table KOTK912 (Sales org./Distr. Chl/Division/Customer/Plant/VAS Mat.gr) preceding to KOTK901 & KOTK922 table.
- Update the program to find the valid VAS code by validating each condition record where multiple records are found.
- Update the program to pick the first condition record where same VAS codes are found for multiple records.
Resolution
Updated the UPC Program- ZRSD_UPC_LABELS.
Below are the test cases were tested in NECNED300 after making the changes in the UPC program.
| Test ID |
Test Scenarios |
Expected Results |
Actual Results |
P/F |
Document # |
Notes |
Tested By |
QA By |
||||||||
| SD0527-1 |
Maintain multiple condition record for Table KOTK912 i.e Sorg/DisCh/Div/Customer/Plant/VAS Matgrp. with below combination. Material should be extended to Sales organisation 2000 & 2200. Create a Purchase order with 2 materials from plant 0325 and execute in ZSD_UPCLBL T.code under UPC (stock items only) with print components unflagged. |
As the valid condition record found from KOTK912 Table with 2000 Sorg combination. So it should be fetched and get printed. And UPC label should be printed correctly with the VAS code maintained in the table KOTK912. |
The condition record fetched from KOTK912 table with sales organisation 2000 combination. And UPC label printed correctly with the VAS code maintained in the table KOTK912. |
P |
PO # 4600008175 |
NA |
Siba |
Siba |
||||||||
| Sorg/DisCh/Div |
Customer |
Plant |
VAS Matgrp. |
Con.Rec. Deleted |
Table |
L Code |
S Code |
Invalid Con.Rec |
||||||||
| 2000/10/00 |
NEC0135 |
0325 |
HDW |
KOTK912 |
LBJ |
S23 |
||||||||||
| 2200/10/00 |
NEC0135 |
0325 |
HDW |
X |
KOTK912 |
LBJ |
S23 |
|||||||||
| SD0527-2 |
Maintain multiple condition record for Table KOTK912 i.e Sorg/DisCh/Div/Customer/Plant/VAS Matgrp. with below combination. Note: Sorg 2000 combination is Invalid Condition record( Both L/S Codes invalid) Sorg 2200 combination is Valid condition record. Material should be extended to Sales organisation 2000 & 2200. Create a Purchase order with 2 materials from plant 0325 and execute in ZSD_UPCLBL T.code under UPC (stock items only) with print components unflagged. |
The condition record should be fetched from KOTK912 table with sales organisation 2200 combination, which is valid. And UPC label should be printed correctly with the VAS code maintained in the table KOTK912. |
The condition record fetched from KOTK912 table with sales organisation 2200 combination, which is valid. And UPC label printed correctly with the VAS code maintained in the table KOTK912. |
P |
PO # 4600008175 |
NA |
Siba |
Siba |
||||||||
| Sorg/DisCh/Div |
Customer |
Plant |
VAS Matgrp. |
Con.Rec. Deleted |
Table |
L Code |
S Code |
Invalid Con.Rec |
||||||||
| 2000/10/00 |
NEC0135 |
0325 |
HDW |
KOTK912 |
L07 |
S41 |
X |
|||||||||
| 2200/10/00 |
NEC0135 |
0325 |
HDW |
KOTK912 |
LBJ |
S23 |
||||||||||
| SD0527-3 |
Maintain multiple condition record for Table KOTK912 i.e Sorg/DisCh/Div/Customer/Plant/VAS Matgrp. with below combination. Note: Sorg 2000 combination is Invalid Condition record (Only L Code invalid) Sorg 2200 combination is Valid condition record. Material should be extended to Sales organisation 2000 & 2200. Create a Purchase order with 2 materials from plant 0325 and execute in ZSD_UPCLBL T.code under UPC (stock items only) with print components unflagged. |
The condition record should be fetched from KOTK912 table with sales organisation 2200 combination, which is valid. And UPC label should be printed correctly with the VAS code maintained in the table KOTK912. |
The condition record fetched from KOTK912 table with sales organisation 2200 combination, which is valid. And UPC label printed correctly with the VAS code maintained in the table KOTK912. |
P |
PO # 4600008175 |
NA |
Siba |
Siba |
||||||||
| Sorg/DisCh/Div |
Customer |
Plant |
VAS Matgrp. |
Con.Rec. Deleted |
Table |
L Code |
S Code |
Invalid Con.Rec |
||||||||
| 2000/10/00 |
NEC0135 |
0325 |
HDW |
KOTK912 |
L07 |
S31 |
X |
|||||||||
| 2200/10/00 |
NEC0135 |
0325 |
HDW |
KOTK912 |
LBJ |
S23 |
||||||||||
| SD0527-4 |
Maintain multiple condition record for Table KOTK912 i.e Sorg/DisCh/Div/Customer/Plant/VAS Matgrp. with below combination. Note: Sorg 2000 combination is Invalid Condition record (Only S Code invalid) Sorg 2200 combination is Valid condition record. Material should be extended to Sales organisation 2000 & 2200. Create a Purchase order with 2 materials from plant 0325 and execute in ZSD_UPCLBL T.code under UPC (stock items only) with print components unflagged. |
The condition record should be fetched from KOTK912 table with sales organisation 2200 combination, which is valid. And UPC label should be printed correctly with the VAS code maintained in the table KOTK912. |
The condition record fetched from KOTK912 table with sales organisation 2200 combination, which is valid. And UPC label printed correctly with the VAS code maintained in the table KOTK912. |
P |
PO # 4600008175 |
NA |
Siba |
Siba |
||||||||
| Sorg/DisCh/Div |
Customer |
Plant |
VAS Matgrp. |
Con.Rec. Deleted |
Table |
L Code |
S Code |
Invalid Con.Rec |
||||||||
| 2000/10/00 |
NEC0135 |
0325 |
HDW |
KOTK912 |
L12 |
S41 |
X |
|||||||||
| 2200/10/00 |
NEC0135 |
0325 |
HDW |
KOTK912 |
LBJ |
S23 |
||||||||||
| SD0527-5 |
Maintain multiple condition record for Table KOTK912 i.e Sorg/DisCh/Div/Customer/Plant/VAS Matgrp. with below combination. Note: Sorg 2000 combination is Invalid Condition record. (Invalid S code) Sorg 2200 combination is Invalid condition record. (Invalid L code) Material should be extended to Sales organisation 2000 & 2200. Create a Purchase order with 2 materials from plant 0325 and execute in ZSD_UPCLBL T.code under UPC (stock items only) with print components unflagged. |
As both condition records are invalid from KOTK912 table. And no other condition records maintained in other VAS tables i.e KOTK901, KOTK922. UPC label should not be printed and pop-up message 'No relevant Lcode or Scode found' should display. |
UPC label not printed and pop-up message 'No relevant Lcode or Scode found' displayed. |
P |
PO # 4600008175 |
NA |
Siba |
Siba |
||||||||
| Sorg/DisCh/Div |
Customer |
Plant |
VAS Matgrp. |
Con.Rec. Deleted |
Table |
L Code |
S Code |
Invalid Con.Rec |
||||||||
| 2000/10/00 |
NEC0135 |
0325 |
HDW |
KOTK912 |
L12 |
S41 |
X |
|||||||||
| 2200/10/00 |
NEC0135 |
0325 |
HDW |
KOTK912 |
L07 |
S23 |
X |
|||||||||
| SD0527-6 |
Maintain multiple condition record for Table KOTK901 i.e Sorg/DisCh/Div/Customer/VAS Matgrp. with below combination. Note: Sorg 2000 combination is Invalid Condition record. (Invalid S code) Sorg 2200 combination is Invalid condition record. (Invalid L code) Material should be extended to Sales organisation 2000 & 2200. Create a Purchase order with 2 materials from plant 0325 and execute in ZSD_UPCLBL T.code under UPC (stock items only) with print components unflagged. |
As both condition records are invalid from KOTK901 table. And no other condition records maintained in other VAS tables i.e KOTK912, KOTK922. UPC label should not be printed and pop-up message 'No relevant Lcode or Scode found' should display. |
UPC label not printed and pop-up message 'No relevant Lcode or Scode found' displayed. |
P |
PO # 4600008175 |
NA |
Siba |
Siba |
||||||||
| Sorg/DisCh/Div |
Customer |
VAS Matgrp. |
Con.Rec. Deleted |
Table |
L Code |
S Code |
Invalid Con.Rec |
|||||||||
| 2000/10/00 |
NEC0135 |
HDW |
KOTK901 |
L12 |
S41 |
X |
||||||||||
| 2200/10/00 |
NEC0135 |
HDW |
KOTK901 |
L07 |
S23 |
X |
||||||||||
| SD0527-7 |
Maintain multiple condition record for Table KOTK922 i.e Sorg/DisCh/Div/Plant. with below combination. Note: Sorg 2000 combination is Invalid Condition record. (Invalid S code) Sorg 2200 combination is Invalid condition record. (Invalid L code) Material should be extended to Sales organisation 2000 & 2200. Create a Purchase order with 2 materials from plant 0325 and execute in ZSD_UPCLBL T.code under UPC (stock items only) with print components unflagged. |
As both condition records are invalid from KOTK922 table. And no other condition records maintained in other VAS tables i.e KOTK912, KOTK901. UPC label should not be printed and pop-up message 'No relevant Lcode or Scode found' should display. |
UPC label not printed and pop-up message 'No relevant Lcode or Scode found' displayed. |
P |
PO # 4600008175 |
NA |
Siba |
Siba |
||||||||
| Sorg/DisCh/Div |
Plant |
Con.Rec. Deleted |
Table |
L Code |
S Code |
Invalid Con.Rec |
||||||||||
| 2000/10/00 |
0325 |
KOTK922 |
L12 |
S41 |
X |
|||||||||||
| 2200/10/00 |
0325 |
KOTK922 |
L07 |
S23 |
X |
|||||||||||
| SD0527-8 |
Maintain multiple condition record for Table KOTK912 i.e Sorg/DisCh/Div/Customer/Plant/VAS Matgrp. with below combination. Note: Sorg 2000 combination is Invalid Condition record. (Invalid L&S code) Sorg 2200 combination is Invalid condition record. (Invalid L&S code) Material should be extended to Sales organisation 2000 & 2200. Create a Purchase order with 2 materials from plant 0325 and execute in ZSD_UPCLBL T.code under UPC (stock items only) with print components unflagged. |
As both condition records are invalid from KOTK912 table. And no other condition records maintained in other VAS tables i.e KOTK901, KOTK922. UPC label should not be printed and pop-up message 'No relevant Lcode or Scode found' should display. |
UPC label not printed and pop-up message 'No relevant Lcode or Scode found' displayed. |
P |
PO # 4600008175 |
NA |
Siba |
Siba |
||||||||
| Sorg/DisCh/Div |
Customer |
Plant |
VAS Matgrp. |
Con.Rec. Deleted |
Table |
L Code |
S Code |
Invalid Con.Rec |
||||||||
| 2000/10/00 |
NEC0135 |
0325 |
HDW |
KOTK912 |
L07 |
S41 |
X |
|||||||||
| 2200/10/00 |
NEC0135 |
0325 |
HDW |
KOTK912 |
L07 |
S41 |
X |
|||||||||
| SD0527-9 |
Maintain multiple condition record for Table KOTK912 i.e Sorg/DisCh/Div/Customer/Plant/VAS Matgrp. with below combination. Note: Both condition record has same valid L code & S code. Material should be extended to Sales organisation 2000 & 2200. Create a Purchase order with 2 materials from plant 0325 and execute in ZSD_UPCLBL T.code under UPC (stock items only) with print components unflagged. |
As both condition records are valid and same Lcode & Scode maintained from KOTK912 table. UPC label should be printed without any extra lines. |
The condition record fetched from KOTK912 table with sales organisation 2000 combination. And UPC label printed without any extra lines. |
P |
PO # 4600008175 |
NA |
Siba |
Siba |
||||||||
| Sorg/DisCh/Div |
Customer |
Plant |
VAS Matgrp. |
Con.Rec. Deleted |
Table |
L Code |
S Code |
Invalid Con.Rec |
||||||||
| 2000/10/00 |
NEC0135 |
0325 |
HDW |
KOTK912 |
LBJ |
S23 |
||||||||||
| 2200/10/00 |
NEC0135 |
0325 |
HDW |
KOTK912 |
LBJ |
S23 |
||||||||||
| SD0527-10 |
Maintain multiple condition record for Table KOTK901 i.e Sorg/DisCh/Div/Customer/VAS Matgrp. with below combination. Note: Both condition record has same valid L code & S code. Material should be extended to Sales organisation 2000 & 2200. Create a Purchase order with 2 materials from plant 0325 and execute in ZSD_UPCLBL T.code under UPC (stock items only) with print components unflagged. |
As both condition records are valid and same Lcode & Scode maintained from KOTK901 table. UPC label should be printed without any extra lines. |
The condition record fetched from KOTK901 table with sales organisation 2000 combination. And UPC label printed without any extra lines. |
P |
PO # 4600008175 |
NA |
Siba |
Siba |
||||||||
| Sorg/DisCh/Div |
Customer |
VAS Matgrp. |
Con.Rec. Deleted |
Table |
L Code |
S Code |
Invalid Con.Rec |
|||||||||
| 2000/10/00 |
NEC0135 |
HDW |
KOTK901 |
L12 |
S31 |
|||||||||||
| 2200/10/00 |
NEC0135 |
HDW |
KOTK901 |
L12 |
S31 |
|||||||||||
| SD0527-11 |
Maintain multiple condition record for Table KOTK922 i.e Sorg/DisCh/Div/Plant. with below combination. Note: Both condition record has same valid L code & S code. Material should be extended to Sales organisation 2000 & 2200. Create a Purchase order with 2 materials from plant 0325 and execute in ZSD_UPCLBL T.code under UPC (stock items only) with print components unflagged. |
As both condition records are valid and same Lcode & Scode maintained from KOTK922 table. UPC label should be printed without any extra lines. |
The condition record fetched from KOTK922 table with sales organisation 2000 combination. And UPC label printed without any extra lines. |
P |
PO # 4600008175 |
NA |
Siba |
Siba |
||||||||
| Sorg/DisCh/Div |
Plant |
Con.Rec. Deleted |
Table |
L Code |
S Code |
Invalid Con.Rec |
||||||||||
| 2000/10/00 |
0325 |
KOTK922 |
L12 |
S23 |
||||||||||||
| 2200/10/00 |
0325 |
KOTK922 |
L12 |
S23 |
||||||||||||
| SD0527-12 |
Maintain multiple condition record for Table KOTK912 i.e Sorg/DisCh/Div/Customer/Plant/VAS Matgrp. with below combination. Note: All condition records are deleted. Material should be extended to Sales organisation 2000 & 2200. Create a Purchase order with 2 materials from plant 0325 and execute in ZSD_UPCLBL T.code under UPC (stock items only) with print components unflagged. |
As both condition records are deleted from KOTK912 table. And no other condition records maintained in other VAS tables i.e KOTK901, KOTK922. UPC label should not be printed and pop-up message 'No relevant Lcode or Scode found' should display. |
UPC label not printed and pop-up message 'No relevant Lcode or Scode found' displayed. |
P |
PO # 4600008175 |
NA |
Siba |
Siba |
||||||||
| Sorg/DisCh/Div |
Customer |
Plant |
VAS Matgrp. |
Con.Rec. Deleted |
Table |
L Code |
S Code |
Invalid Con.Rec |
||||||||
| 2000/10/00 |
NEC0135 |
0325 |
HDW |
X |
KOTK912 |
LBJ |
S23 |
|||||||||
| 2200/10/00 |
NEC0135 |
0325 |
HDW |
X |
KOTK912 |
L12 |
S31 |
|||||||||
| SD0527-13 |
Maintain multiple condition records for table KOTK912, 901 & 922 as below; Material should be extended to Sales organisation 2000 & 2200. Create a Purchase order with 2 materials from plant 0325 and execute in ZSD_UPCLBL T.code under UPC (stock items only) with print components unflagged. |
Program should check Tables sequentially like KOTK912, KOTK901 & KOTK922. UPC from KOTK922 with Sorg 2200 combination should be printed with the maintained VAS codes as it is found valid condtion record with non delition indicator. |
UPC label printed with the VAS code maintained in the KOTK922 table with Sorg 2200 combination. |
P |
PO # 4600008175 |
NA |
Siba |
Siba |
||||||||
| Sorg/DisCh/Div |
Customer |
Plant |
VAS Matgrp. |
Con.Rec. Deleted |
Table |
L Code |
S Code |
Invalid Con.Rec |
||||||||
| 2000/10/00 |
NEC0135 |
0325 |
HDW |
KOTK912 |
LBJ |
S41 |
X |
|||||||||
| 2200/10/00 |
NEC0135 |
0325 |
HDW |
KOTK912 |
LBJ |
S41 |
X |
|||||||||
| Sorg/DisCh/Div |
Customer |
VAS Matgrp. |
Con.Rec. Deleted |
Table |
L Code |
S Code |
Invalid Con.Rec |
|||||||||
| 2000/10/00 |
NEC0135 |
HDW |
X |
KOTK901 |
LBJ |
S23 |
||||||||||
| 2200/10/00 |
NEC0135 |
HDW |
KOTK901 |
L07 |
S31 |
X |
||||||||||
| Sorg/DisCh/Div |
Plant |
Con.Rec. Deleted |
Table |
L Code |
S Code |
Invalid Con.Rec |
||||||||||
| 2000/10/00 |
0325 |
X |
KOTK922 |
LBJ |
S23 |
|||||||||||
| 2200/10/00 |
0325 |
KOTK922 |
L12 |
S31 |
||||||||||||
Below are the screen shots after execution of above test cases.
SD0527-1
SD0527-2
SD0527-3
SD0527-4
SD0527-5
SD0527-6
SD0527-7
SD0527-8
SD0527-9
SD0527-10
SD0527-11
SD0527-12
SD0527-13
Below attached file is the test data created in NECNEQ100 after TR is moved:
NEQ100_TestData_UPC_MulConRec_0831.xlsx
Solution Details:
1. For PO input in the UPC labels, we validated condition records to get the valid S codes and L codes.
2. Added KOTK912 condition records tables and get the condition records number by passing customer number, sales org,plant etc.
3. Once we get the condition records number, condition records will be excluded if it is having deletion indicator checked.
4. if the valid condition record number found, we are passing the corresponding condition records number into the j_3avast and j_3avass tables to get the valid S codes and L codes.
Release Information
2015-08-18 - 19505 - Rel Notes - Update UPC Program